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/Multidimensional 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


9/17/2018 - Version 1.2a - Now the converter will only split at new lines not in double quotes.

8/6/2018 - Version 1.2 - There is now an option to "Convert to Multidimensional Array" for both Javascript and PHP.

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 December 16, 2020
Created on August 22, 2014

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

User Comments

There are 18 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.

13. Posted By: Nic - - February 8, 2018, 2:37 pm
Also I think it would be nice if it wrapped the "convert to array" function to wrap the array in var array=[ ]. Or maybe an input box that would take the var name.

This is a helpful tool though. Thanks

14. Posted By: Taghouti Tarek - - June 27, 2020, 3:58 am
Thanx, it's so helpful you made my day

15. Posted By: typo - - November 17, 2020, 11:55 pm
Thank you! worked perfectly. Really saved me a lot of time!

16. Posted By: Hossein - - December 5, 2020, 11:44 pm
Thank u so much. I use it for unit testing. It boosts test process time for me. Good luck

17. Posted By: hailemelekot - - January 1, 2021, 1:03 am
It is a very nice job. It saves me a lot of time and effort! Thank you and keep the good job!!!

18. Posted By: Jim - - January 9, 2021, 3:11 am
You can try this converter