Excel Spreadsheet to Array Converter

or csv to Array or HTML Table Online Converter

Last updated on
Subscribe to Internet Tips and Tools Feed

Table Options:

Array Options:
Surround With:


Associative Array Options:

Keys are in:

Instructions

Copy and Paste the cells from an Excel Spreadsheet (XLS, XLSX) or other spreadsheet or table or CSV file into the textarea above and press one of the convert buttons. The converter will try to best determine if the data is delimited with commas or tabs by counting the commas and tabs. If you choose to convert the spreadsheet into an html table then the converter will show a preview of the table.

Copyright © 2014 by Jeff Baker

History

1/14/2016 - Version 1.1c - As per request added an option to "Convert numbers to strings".

12/23/2015 - Version 1.1b - Fixed a bug where if blank fields were removed sometimes an extra comma was still displayed.

12/17/2015 - Version 1.1a - Added option to remove blank fields from arrays and associative arrays.

8/25/2014 - Version 1.1 - Added option for headers in left column when converting to table.

8/22/2014 - Version 1.0 - Spreadsheet or CSV file to array or html table converter created.

Last updated on January 2, 2017
Created on August 22, 2014

Back to www.seabreezecomputers.com
Subscribe to Internet Tips and Tools Feed        

User Comments

There are 6 comments.

Displaying first 50 comments.

1. Posted By: MG - - January 6, 2016, 9:14 am
Would be nice to have option to keep number cells as a string javascript property

2. Posted By: Jeff - - January 14, 2016, 6:40 pm
Hello MG,

As you requested, there is now an option on the converter to "Convert numbers to strings". Let me know if it works for you.

Jeff
www.seabreezecomputers.com/excel2array/

3. Posted By: MG - - January 27, 2016, 4:42 pm
Nice just tried it and it works perfectly! Thank you!

MG

4. Posted By: Ajit - - May 24, 2016, 5:19 am
Brilliant. Works like a charm. Thank You. This saved me several minutes of work. Converted my CSV into an associative array with ease.

5. Posted By: al - - December 1, 2016, 4:04 am
it would be good if it could recognise arrays rather than converting them to strings

[2,5,6,7,2,6]

6. Posted By: Jeff - - December 1, 2016, 11:35 am
Hi al,

I'm not sure I understand what you mean. What is your original data? And what is your expected output? The converter doesn't convert numbers to strings unless the "Convert numbers to strings" box is checked.


Jeff
www.seabreezecomputers.com/