Excel Spreadsheet to Array Converter

or csv to Array or HTML Table Online Converter

Last updated on
((( spellific )))
Practice spelling while playing a fun word game!
Click here to play
Speech Recognition Anywhere
  • Type emails with your voice
  • Write documents with your voice
  • Control the Inernet with your voice
  • Chrome Extension
Reconocimiento de voz en cualquier lugar
  • Escribe correos electrónicos con tu voz
  • Escribe documentos con tu voz
  • Controla la Inernet con tu voz
  • Extensión de Chrome
Spracherkennung Allerorts
  • Geben Sie E-Mails mit Ihrer Stimme ein
  • Schreiben Sie Dokumente mit Ihrer Stimme
  • Steuern Sie das Internet mit Ihrer Stimme
  • Chrome-Erweiterung
Reconnaissance de la parole
  • Tapez des e-mails avec votre voix
  • Écrivez des documents avec votre voix
  • Contrôlez l'Inernet avec votre voix
  • Extension Chrome
Riconoscimento vocale ovunque
  • Digita e-mail con la tua voce
  • Scrivi documenti con la tua voce
  • Controlla Internet con la tua voce
  • Estensione Chrome
どこでも
音声認識
  • あなたの声で文書を書く
  • あなたの声でメールを入力してください
  • あなたの声でInernetを制御する
  • Chrome拡張機能
语音识别
无处不在
  • 用你的声音写文件
  • 用您的声音输入电子邮件
  • 用你的声音控制互联网
  • Chrome 扩展程序
語音識別
無處不在
  • 用你的聲音寫文件
  • 用您的聲音輸入電子郵件
  • 用你的聲音控制互聯網
  • Chrome 擴展程序
Subscribe to Internet Tips and Tools Feed

Table Options:

Array Options:
Surround With:


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

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

((( spellific )))
Practice spelling while playing a fun word game!
Click here to play
Speech Recognition Anywhere
  • Type emails with your voice
  • Write documents with your voice
  • Control the Inernet with your voice
  • Chrome Extension
Reconocimiento de voz en cualquier lugar
  • Escribe correos electrónicos con tu voz
  • Escribe documentos con tu voz
  • Controla la Inernet con tu voz
  • Extensión de Chrome
Spracherkennung Allerorts
  • Geben Sie E-Mails mit Ihrer Stimme ein
  • Schreiben Sie Dokumente mit Ihrer Stimme
  • Steuern Sie das Internet mit Ihrer Stimme
  • Chrome-Erweiterung
Reconnaissance de la parole
  • Tapez des e-mails avec votre voix
  • Écrivez des documents avec votre voix
  • Contrôlez l'Inernet avec votre voix
  • Extension Chrome
Riconoscimento vocale ovunque
  • Digita e-mail con la tua voce
  • Scrivi documenti con la tua voce
  • Controlla Internet con la tua voce
  • Estensione Chrome
どこでも
音声認識
  • あなたの声で文書を書く
  • あなたの声でメールを入力してください
  • あなたの声でInernetを制御する
  • Chrome拡張機能
语音识别
无处不在
  • 用你的声音写文件
  • 用您的声音输入电子邮件
  • 用你的声音控制互联网
  • Chrome 扩展程序
語音識別
無處不在
  • 用你的聲音寫文件
  • 用您的聲音輸入電子郵件
  • 用你的聲音控制互聯網
  • Chrome 擴展程序
Back to www.seabreezecomputers.com
Subscribe to Internet Tips and Tools Feed        

User Comments

There are 24 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/

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
wtools.io/convert-excel-to-php-array

19. Posted By: Arnaud - - November 9, 2021, 9:07 am
Thanks for creating and sharing that tool, it saved me quite some time ;)

20. Posted By: User - - January 7, 2022, 6:27 am
How come the double quotes were removed? It was so helpful

21. Posted By: Jeff - - January 7, 2022, 11:35 am
Hi User,

Double quotes are still there. Nothing has changed. If you mean that numbers are not surrounded by quotes then you have to check the box "Convert numbers to strings".

Jeff
http://www.seabreezecomputers.com/

22. Posted By: GG dev - - January 10, 2022, 2:36 am
this system helps our company daily task. Thank you for the service, we appreciate your effort. thank you very much


23. Posted By: Jeff - - January 10, 2022, 12:45 pm
Hi GG dev,

You're welcome! Thank you for the comment!

Jeff
http://www.seabreezecomputers.com/

24. Posted By: A.M. - - February 5, 2024, 3:45 am
Very helpful!