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:


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


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 12 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.


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


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


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.


7. Posted By: Kevin Bridges - - January 26, 2017, 6:05 am
Thanks for this awesome little utility. Worked perfectly and saved me a ton of time!

8. Posted By: Anjali - - March 2, 2017, 4:43 pm
Awesome! works like a charm. Thank you for saving ton of my time.

9. Posted By: Woodsy - - June 19, 2017, 7:45 pm
You just saved me many extremely boring hours.. Thank you, thank you, thank you!

10. Posted By: DBalto - - June 25, 2017, 2:03 pm
Perfect!~ Mucho Gracias!

11. Posted By: K - - December 19, 2017, 3:41 am
Thank you so much for this!

12. Posted By: Kevin Miller - - December 19, 2017, 1:04 pm
Perfect tool for converting excel columns into array of string. This has saved me so much time today at work. Big thank you.